04/16/21 - 15:37

Dataset statistics

Number of variables	22
Number of observations	428
Missing cells	3510
Missing cells (%)	37.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	102.1 KiB
Average record size in memory	244.3 B

Variable types

Numeric	10
Unsupported	8
Categorical	4

Warnings

`adm` has constant value "20.0"	Constant
`operation_car` has constant value "13.0"	Constant
`operation_date` has a high cardinality: 279 distinct values	High cardinality
`rodvag` is highly correlated with `operation_car` and 1 other fields	High correlation
`operation_car` is highly correlated with `rodvag` and 1 other fields	High correlation
`adm` is highly correlated with `rodvag` and 1 other fields	High correlation
`index_train` has 428 (100.0%) missing values	Missing
`danger` has 428 (100.0%) missing values	Missing
`loaded` has 428 (100.0%) missing values	Missing
`operation_st_esr` has 43 (10.0%) missing values	Missing
`operation_st_id` has 43 (10.0%) missing values	Missing
`operation_train` has 428 (100.0%) missing values	Missing
`rod_train` has 428 (100.0%) missing values	Missing
`ssp_station_esr` has 428 (100.0%) missing values	Missing
`ssp_station_id` has 428 (100.0%) missing values	Missing
`weight_brutto` has 428 (100.0%) missing values	Missing
`df_index` has unique values	Unique
`car_number` has unique values	Unique
`index_train` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`danger` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`loaded` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`operation_train` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`rod_train` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`ssp_station_esr` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`ssp_station_id` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`weight_brutto` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`receiver` has 143 (33.4%) zeros	Zeros
`sender` has 103 (24.1%) zeros	Zeros

Reproduction

Analysis started	2021-04-16 09:37:47.561061
Analysis finished	2021-04-16 09:38:08.492320
Duration	20.93 seconds
Software version	pandas-profiling v2.11.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	428
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2246478.082
Minimum	11081
Maximum	4163938
Zeros	0
Zeros (%)	0.0%
Memory size	3.5 KiB

Quantile statistics

Minimum	11081
5-th percentile	343299.8
Q1	1131633.75
median	2591860
Q3	3292319.5
95-th percentile	4014152.55
Maximum	4163938
Range	4152857
Interquartile range (IQR)	2160685.75

Descriptive statistics

Standard deviation	1248260.456
Coefficient of variation (CV)	0.5556521854
Kurtosis	-1.293025121
Mean	2246478.082
Median Absolute Deviation (MAD)	1096911.5
Skewness	-0.1568934861
Sum	961492619
Variance	1.558154165 × 10¹²
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2866180	1	0.2%
2921149	1	0.2%
3974308	1	0.2%
2731697	1	0.2%
2917040	1	0.2%
3874479	1	0.2%
2846381	1	0.2%
3015199	1	0.2%
371370	1	0.2%
4017138	1	0.2%
Other values (418)	418	97.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
11081	1	0.2%
11847	1	0.2%
12276	1	0.2%
12516	1	0.2%
12796	1	0.2%
13479	1	0.2%
13592	1	0.2%
14464	1	0.2%
14700	1	0.2%
17494	1	0.2%

Value	Count	Frequency (%)
4163938	1	0.2%
4147633	1	0.2%
4111004	1	0.2%
4110631	1	0.2%
4102757	1	0.2%
4102574	1	0.2%
4097772	1	0.2%
4083113	1	0.2%
4067152	1	0.2%
4055756	1	0.2%

index_train
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	428
Missing (%)	100.0%
Memory size	3.5 KiB

length
Real number (ℝ_≥0)

Distinct	6
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.249415888
Minimum	1
Maximum	1.85
Zeros	0
Zeros (%)	0.0%
Memory size	3.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1.41
95-th percentile	1.85
Maximum	1.85
Range	0.85
Interquartile range (IQR)	0.41

Descriptive statistics

Standard deviation	0.3496326408
Coefficient of variation (CV)	0.2798368776
Kurtosis	-0.977975317
Mean	1.249415888
Median Absolute Deviation (MAD)	0
Skewness	0.9150809001
Sum	534.75
Variance	0.1222429835
Monotocity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	230	53.7%
1.82	58	13.6%
1.06	51	11.9%
1.41	44	10.3%
1.85	37	8.6%
1.83	8	1.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	230	53.7%
1.06	51	11.9%
1.41	44	10.3%
1.82	58	13.6%
1.83	8	1.9%
1.85	37	8.6%

Value	Count	Frequency (%)
1.85	37	8.6%
1.83	8	1.9%
1.82	58	13.6%
1.41	44	10.3%
1.06	51	11.9%
1	230	53.7%

car_number
Real number (ℝ_≥0)

UNIQUE

Distinct	428
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	72474499.94
Minimum	42162669
Maximum	98096902
Zeros	0
Zeros (%)	0.0%
Memory size	3.5 KiB

Quantile statistics

Minimum	42162669
5-th percentile	52765525.6
Q1	55713091.5
median	61895837
Q3	94484090.25
95-th percentile	98037953.85
Maximum	98096902
Range	55934233
Interquartile range (IQR)	38770998.75

Descriptive statistics

Standard deviation	19040806.94
Coefficient of variation (CV)	0.2627242265
Kurtosis	-1.767685953
Mean	72474499.94
Median Absolute Deviation (MAD)	8459214.5
Skewness	0.32127804
Sum	3.101908598 × 10¹⁰
Variance	3.62552329 × 10¹⁴
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
55150593	1	0.2%
57808610	1	0.2%
53470944	1	0.2%
61099743	1	0.2%
58753757	1	0.2%
94539483	1	0.2%
52723418	1	0.2%
95086294	1	0.2%
55773907	1	0.2%
59188946	1	0.2%
Other values (418)	418	97.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
42162669	1	0.2%
42301762	1	0.2%
42681635	1	0.2%
43348911	1	0.2%
52175866	1	0.2%
52188133	1	0.2%
52235066	1	0.2%
52266517	1	0.2%
52311081	1	0.2%
52503307	1	0.2%

Value	Count	Frequency (%)
98096902	1	0.2%
98096894	1	0.2%
98096837	1	0.2%
98096779	1	0.2%
98096274	1	0.2%
98095730	1	0.2%
98095706	1	0.2%
98095649	1	0.2%
98087000	1	0.2%
98077076	1	0.2%

destination_esr
Real number (ℝ_≥0)

Distinct	37
Distinct (%)	8.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	687292.8435
Minimum	15805
Maximum	988306
Zeros	0
Zeros (%)	0.0%
Memory size	3.5 KiB

Quantile statistics

Minimum	15805
5-th percentile	181102
Q1	547302
median	817600
Q3	817600
95-th percentile	895703
Maximum	988306
Range	972501
Interquartile range (IQR)	270298

Descriptive statistics

Standard deviation	256585.1611
Coefficient of variation (CV)	0.3733272702
Kurtosis	0.1351110673
Mean	687292.8435
Median Absolute Deviation (MAD)	70003
Skewness	-1.230644345
Sum	294161337
Variance	6.583594487 × 10¹⁰
Monotocity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
817600	140	32.7%
887603	45	10.5%
181102	42	9.8%
547302	24	5.6%
797303	24	5.6%
645100	22	5.1%
988306	18	4.2%
230506	18	4.2%
895703	18	4.2%
892103	11	2.6%
Other values (27)	66	15.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
15805	1	0.2%
18409	1	0.2%
35508	2	0.5%
35601	1	0.2%
38205	3	0.7%
181102	42	9.8%
181808	2	0.5%
205307	3	0.7%
205608	1	0.2%
220504	1	0.2%

Value	Count	Frequency (%)
988306	18	4.2%
970001	1	0.2%
895807	1	0.2%
895703	18	4.2%
892103	11	2.6%
887603	45	10.5%
850204	1	0.2%
831203	1	0.2%
817600	140	32.7%
797407	7	1.6%

adm
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	25.6 KiB

20.0	428

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	1712
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	20.0
2nd row	20.0
3rd row	20.0
4th row	20.0
5th row	20.0

Value	Count	Frequency (%)
20.0	428	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
20.0	428	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	856	50.0%
2	428	25.0%
.	428	25.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1284	75.0%
Other Punctuation	428	25.0%

Most frequent character per category

Value	Count	Frequency (%)
0	856	66.7%
2	428	33.3%

Value	Count	Frequency (%)
.	428	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1712	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	856	50.0%
2	428	25.0%
.	428	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1712	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	856	50.0%
2	428	25.0%
.	428	25.0%

danger
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	428
Missing (%)	100.0%
Memory size	3.5 KiB

gruz
Real number (ℝ_≥0)

Distinct	13
Distinct (%)	3.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	326531.9206
Minimum	3009
Maximum	693176
Zeros	0
Zeros (%)	0.0%
Memory size	3.5 KiB

Quantile statistics

Minimum	3009
5-th percentile	3009
Q1	3009
median	351043
Q3	693176
95-th percentile	693176
Maximum	693176
Range	690167
Interquartile range (IQR)	690167

Descriptive statistics

Standard deviation	269724.0541
Coefficient of variation (CV)	0.8260266061
Kurtosis	-1.401900099
Mean	326531.9206
Median Absolute Deviation (MAD)	342133
Skewness	0.1251166908
Sum	139755662
Variance	7.275106538 × 10¹⁰
Monotocity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
3009	136	31.8%
693176	116	27.1%
391483	57	13.3%
241604	24	5.6%
323024	24	5.6%
151060	18	4.2%
412196	15	3.5%
351306	13	3.0%
351043	12	2.8%
452333	8	1.9%
Other values (3)	5	1.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3009	136	31.8%
151060	18	4.2%
241604	24	5.6%
323024	24	5.6%
323058	3	0.7%
351039	1	0.2%
351043	12	2.8%
351306	13	3.0%
391483	57	13.3%
412196	15	3.5%

Value	Count	Frequency (%)
693176	116	27.1%
452333	8	1.9%
452028	1	0.2%
412196	15	3.5%
391483	57	13.3%
351306	13	3.0%
351043	12	2.8%
351039	1	0.2%
323058	3	0.7%
323024	24	5.6%

loaded
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	428
Missing (%)	100.0%
Memory size	3.5 KiB

operation_car
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	25.6 KiB

13.0	428

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	1712
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	13.0
2nd row	13.0
3rd row	13.0
4th row	13.0
5th row	13.0

Value	Count	Frequency (%)
13.0	428	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
13.0	428	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	428	25.0%
3	428	25.0%
.	428	25.0%
0	428	25.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1284	75.0%
Other Punctuation	428	25.0%

Most frequent character per category

Value	Count	Frequency (%)
1	428	33.3%
3	428	33.3%
0	428	33.3%

Value	Count	Frequency (%)
.	428	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1712	100.0%

Most frequent character per script

Value	Count	Frequency (%)
1	428	25.0%
3	428	25.0%
.	428	25.0%
0	428	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1712	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	428	25.0%
3	428	25.0%
.	428	25.0%
0	428	25.0%

operation_date
Categorical

HIGH CARDINALITY

Distinct	279
Distinct (%)	65.2%
Missing	0
Missing (%)	0.0%
Memory size	31.9 KiB

2020-07-04 14:31:00	16
2020-07-02 02:15:00	15
2020-07-10 16:17:00	15
2020-07-22 10:28:00	13
2020-07-26 04:00:00	10
Other values (274)	359

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	8132
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	232 ?
Unique (%)	54.2%

Sample

1st row	2020-07-16 15:42:00
2nd row	2020-07-15 21:29:00
3rd row	2020-07-15 21:15:00
4th row	2020-07-16 13:31:00
5th row	2020-07-16 17:10:00

Value	Count	Frequency (%)
2020-07-04 14:31:00	16	3.7%
2020-07-02 02:15:00	15	3.5%
2020-07-10 16:17:00	15	3.5%
2020-07-22 10:28:00	13	3.0%
2020-07-26 04:00:00	10	2.3%
2020-07-26 06:23:00	9	2.1%
2020-07-26 03:55:00	8	1.9%
2020-07-23 14:55:00	7	1.6%
2020-07-17 21:03:00	6	1.4%
2020-07-02 02:09:00	5	1.2%
Other values (269)	324	75.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
2020-07-15	45	5.3%
2020-07-26	35	4.1%
2020-07-22	31	3.6%
2020-07-02	26	3.0%
2020-07-30	24	2.8%
2020-07-17	24	2.8%
2020-07-12	23	2.7%
2020-07-16	20	2.3%
2020-07-23	20	2.3%
2020-07-19	19	2.2%
Other values (260)	589	68.8%

Most occurring characters

Value	Count	Frequency (%)
0	2595	31.9%
2	1262	15.5%
-	856	10.5%
:	856	10.5%
1	581	7.1%
7	565	6.9%
	428	5.3%
3	243	3.0%
5	227	2.8%
6	170	2.1%
Other values (3)	349	4.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5992	73.7%
Dash Punctuation	856	10.5%
Other Punctuation	856	10.5%
Space Separator	428	5.3%

Most frequent character per category

Value	Count	Frequency (%)
0	2595	43.3%
2	1262	21.1%
1	581	9.7%
7	565	9.4%
3	243	4.1%
5	227	3.8%
6	170	2.8%
4	161	2.7%
8	104	1.7%
9	84	1.4%

Value	Count	Frequency (%)
-	856	100.0%

Value	Count	Frequency (%)
	428	100.0%

Value	Count	Frequency (%)
:	856	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	8132	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	2595	31.9%
2	1262	15.5%
-	856	10.5%
:	856	10.5%
1	581	7.1%
7	565	6.9%
	428	5.3%
3	243	3.0%
5	227	2.8%
6	170	2.1%
Other values (3)	349	4.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8132	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	2595	31.9%
2	1262	15.5%
-	856	10.5%
:	856	10.5%
1	581	7.1%
7	565	6.9%
	428	5.3%
3	243	3.0%
5	227	2.8%
6	170	2.1%
Other values (3)	349	4.3%

operation_st_esr
Real number (ℝ_≥0)

MISSING

Distinct	10
Distinct (%)	2.6%
Missing	43
Missing (%)	10.0%
Infinite	0
Infinite (%)	0.0%

Mean	963201.5844
Minimum	891909
Maximum	986103
Zeros	0
Zeros (%)	0.0%
Memory size	3.5 KiB

Quantile statistics

Minimum	891909
5-th percentile	891909
Q1	980200
median	980200
Q3	980709
95-th percentile	986103
Maximum	986103
Range	94194
Interquartile range (IQR)	509

Descriptive statistics

Standard deviation	34056.83059
Coefficient of variation (CV)	0.03535794702
Kurtosis	0.1977035368
Mean	963201.5844
Median Absolute Deviation (MAD)	509
Skewness	-1.411196694
Sum	370832610
Variance	1159867710
Monotocity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
980200	119	27.8%
891909	60	14.0%
980605	42	9.8%
980709	40	9.3%
927209	31	7.2%
986103	26	6.1%
985100	24	5.6%
980501	22	5.1%
984700	18	4.2%
980107	3	0.7%
(Missing)	43	10.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
891909	60	14.0%
927209	31	7.2%
980107	3	0.7%
980200	119	27.8%
980501	22	5.1%
980605	42	9.8%
980709	40	9.3%
984700	18	4.2%
985100	24	5.6%
986103	26	6.1%

Value	Count	Frequency (%)
986103	26	6.1%
985100	24	5.6%
984700	18	4.2%
980709	40	9.3%
980605	42	9.8%
980501	22	5.1%
980200	119	27.8%
980107	3	0.7%
927209	31	7.2%
891909	60	14.0%

operation_st_id
Real number (ℝ_≥0)

MISSING

Distinct	10
Distinct (%)	2.6%
Missing	43
Missing (%)	10.0%
Infinite	0
Infinite (%)	0.0%

Mean	2001809383
Minimum	2000038848
Maximum	2002030157
Zeros	0
Zeros (%)	0.0%
Memory size	3.5 KiB

Quantile statistics

Minimum	2000038848
5-th percentile	2000038848
Q1	2002024431
median	2002025607
Q3	2002025651
95-th percentile	2002030157
Maximum	2002030157
Range	1991309
Interquartile range (IQR)	1220

Descriptive statistics

Standard deviation	620367.2615
Coefficient of variation (CV)	0.0003099032638
Kurtosis	4.360967968
Mean	2001809383
Median Absolute Deviation (MAD)	778
Skewness	-2.517587851
Sum	7.706966126 × 10¹¹
Variance	3.848555392 × 10¹¹
Monotocity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2002025607	119	27.8%
2002024431	60	14.0%
2000038848	42	9.8%
2002030133	40	9.3%
2002024829	31	7.2%
2002025661	26	6.1%
2002030157	24	5.6%
2002025609	22	5.1%
2002025651	18	4.2%
2002025605	3	0.7%
(Missing)	43	10.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2000038848	42	9.8%
2002024431	60	14.0%
2002024829	31	7.2%
2002025605	3	0.7%
2002025607	119	27.8%
2002025609	22	5.1%
2002025651	18	4.2%
2002025661	26	6.1%
2002030133	40	9.3%
2002030157	24	5.6%

Value	Count	Frequency (%)
2002030157	24	5.6%
2002030133	40	9.3%
2002025661	26	6.1%
2002025651	18	4.2%
2002025609	22	5.1%
2002025607	119	27.8%
2002025605	3	0.7%
2002024829	31	7.2%
2002024431	60	14.0%
2000038848	42	9.8%

operation_train
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	428
Missing (%)	100.0%
Memory size	3.5 KiB

receiver
Real number (ℝ_≥0)

ZEROS

Distinct	14
Distinct (%)	3.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	9949365.22
Minimum	0
Maximum	95687583
Zeros	143
Zeros (%)	33.4%
Memory size	3.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	186424
Q3	16111351
95-th percentile	48962205
Maximum	95687583
Range	95687583
Interquartile range (IQR)	16111351

Descriptive statistics

Standard deviation	21340115.67
Coefficient of variation (CV)	2.14487208
Kurtosis	8.702955192
Mean	9949365.22
Median Absolute Deviation (MAD)	186424
Skewness	2.953674798
Sum	4258328314
Variance	4.55400537 × 10¹⁴
Monotocity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
0	143	33.4%
186424	140	32.7%
16111351	42	9.8%
5753490	31	7.2%
29317054	22	5.1%
29381833	18	4.2%
95687583	18	4.2%
48962205	3	0.7%
186849	3	0.7%
67736348	3	0.7%
Other values (4)	5	1.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	143	33.4%
186424	140	32.7%
186803	1	0.2%
186849	3	0.7%
5753490	31	7.2%
16111351	42	9.8%
16146214	1	0.2%
29317054	22	5.1%
29381833	18	4.2%
30486299	1	0.2%

Value	Count	Frequency (%)
95687583	18	4.2%
67736348	3	0.7%
48962205	3	0.7%
41746912	2	0.5%
30486299	1	0.2%
29381833	18	4.2%
29317054	22	5.1%
16146214	1	0.2%
16111351	42	9.8%
5753490	31	7.2%

rodvag
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	25.6 KiB

60.0	230
96.0	192
40.0	6

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	1712
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	96.0
2nd row	96.0
3rd row	96.0
4th row	96.0
5th row	96.0

Value	Count	Frequency (%)
60.0	230	53.7%
96.0	192	44.9%
40.0	6	1.4%

Histogram of lengths of the category

Value	Count	Frequency (%)
60.0	230	53.7%
96.0	192	44.9%
40.0	6	1.4%

Most occurring characters

Value	Count	Frequency (%)
0	664	38.8%
.	428	25.0%
6	422	24.6%
9	192	11.2%
4	6	0.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1284	75.0%
Other Punctuation	428	25.0%

Most frequent character per category

Value	Count	Frequency (%)
0	664	51.7%
6	422	32.9%
9	192	15.0%
4	6	0.5%

Value	Count	Frequency (%)
.	428	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1712	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	664	38.8%
.	428	25.0%
6	422	24.6%
9	192	11.2%
4	6	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1712	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	664	38.8%
.	428	25.0%
6	422	24.6%
9	192	11.2%
4	6	0.4%

rod_train
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	428
Missing (%)	100.0%
Memory size	3.5 KiB

sender
Real number (ℝ_≥0)

ZEROS

Distinct	11
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11102101.03
Minimum	0
Maximum	74981099
Zeros	103
Zeros (%)	24.1%
Memory size	3.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1125133
median	1126016
Q3	10238843
95-th percentile	73262854
Maximum	74981099
Range	74981099
Interquartile range (IQR)	9113710

Descriptive statistics

Standard deviation	20584041.56
Coefficient of variation (CV)	1.854067217
Kurtosis	4.203037918
Mean	11102101.03
Median Absolute Deviation (MAD)	1126016
Skewness	2.304337655
Sum	4751699242
Variance	4.237027671 × 10¹⁴
Monotocity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
1126016	118	27.6%
0	103	24.1%
10238843	64	15.0%
3144627	31	7.2%
73262854	26	6.1%
1125133	24	5.6%
27036995	24	5.6%
31170931	18	4.2%
1373772	10	2.3%
74981099	9	2.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	103	24.1%
1125133	24	5.6%
1126016	118	27.6%
1373772	10	2.3%
3144627	31	7.2%
10238843	64	15.0%
27036995	24	5.6%
31170931	18	4.2%
35690320	1	0.2%
73262854	26	6.1%

Value	Count	Frequency (%)
74981099	9	2.1%
73262854	26	6.1%
35690320	1	0.2%
31170931	18	4.2%
27036995	24	5.6%
10238843	64	15.0%
3144627	31	7.2%
1373772	10	2.3%
1126016	118	27.6%
1125133	24	5.6%

ssp_station_esr
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	428
Missing (%)	100.0%
Memory size	3.5 KiB

ssp_station_id
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	428
Missing (%)	100.0%
Memory size	3.5 KiB

tare_weight
Real number (ℝ_≥0)

Distinct	41
Distinct (%)	9.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	237.1285047
Minimum	194
Maximum	261
Zeros	0
Zeros (%)	0.0%
Memory size	3.5 KiB

Quantile statistics

Minimum	194
5-th percentile	208.35
Q1	235
median	240
Q3	243
95-th percentile	250
Maximum	261
Range	67
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	12.76796454
Coefficient of variation (CV)	0.05384407312
Kurtosis	3.094479163
Mean	237.1285047
Median Absolute Deviation (MAD)	5
Skewness	-1.746332389
Sum	101491
Variance	163.0209186
Monotocity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
250	88	20.6%
240	82	19.2%
238	33	7.7%
235	31	7.2%
243	18	4.2%
242	18	4.2%
233	17	4.0%
239	16	3.7%
241	13	3.0%
195	10	2.3%
Other values (31)	102	23.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
194	2	0.5%
195	10	2.3%
196	3	0.7%
200	3	0.7%
205	1	0.2%
206	1	0.2%
207	1	0.2%
208	1	0.2%
209	2	0.5%
210	10	2.3%

Value	Count	Frequency (%)
261	1	0.2%
250	88	20.6%
248	2	0.5%
247	1	0.2%
246	3	0.7%
245	5	1.2%
244	6	1.4%
243	18	4.2%
242	18	4.2%
241	13	3.0%

weight_brutto
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	428
Missing (%)	100.0%
Memory size	3.5 KiB

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	df_index	index_train	length	car_number	destination_esr	adm	danger	gruz	loaded	operation_car	operation_date	operation_st_esr	operation_st_id	operation_train	receiver	rodvag	rod_train	sender	ssp_station_esr	ssp_station_id	tare_weight	weight_brutto
0	11081	NaN	1.06	94496304	525407.0	20.0	NaN	3009.0	NaN	13.0	2020-07-16 15:42:00	980107.0	2.002026e+09	NaN	0.0	96.0	NaN	0.0	NaN	NaN	195.0	NaN
1	11847	NaN	1.83	94644499	35601.0	20.0	NaN	3009.0	NaN	13.0	2020-07-15 21:29:00	986103.0	2.002026e+09	NaN	48962205.0	96.0	NaN	73262854.0	NaN	NaN	246.0	NaN
2	12276	NaN	1.83	94694692	35508.0	20.0	NaN	3009.0	NaN	13.0	2020-07-15 21:15:00	986103.0	2.002026e+09	NaN	48962205.0	96.0	NaN	73262854.0	NaN	NaN	248.0	NaN
3	12516	NaN	1.41	94778487	892103.0	20.0	NaN	391483.0	NaN	13.0	2020-07-16 13:31:00	891909.0	2.002024e+09	NaN	0.0	96.0	NaN	0.0	NaN	NaN	246.0	NaN
4	12796	NaN	1.41	94798659	525407.0	20.0	NaN	3009.0	NaN	13.0	2020-07-16 17:10:00	980709.0	2.002030e+09	NaN	0.0	96.0	NaN	0.0	NaN	NaN	240.0	NaN
5	13479	NaN	1.06	94292455	525407.0	20.0	NaN	3009.0	NaN	13.0	2020-07-16 17:15:00	980709.0	2.002030e+09	NaN	0.0	96.0	NaN	0.0	NaN	NaN	240.0	NaN
6	13592	NaN	1.06	94309887	887603.0	20.0	NaN	391483.0	NaN	13.0	2020-07-16 11:57:00	891909.0	2.002024e+09	NaN	0.0	96.0	NaN	0.0	NaN	NaN	220.0	NaN
7	14464	NaN	1.06	94430402	887603.0	20.0	NaN	391483.0	NaN	13.0	2020-07-16 13:00:00	891909.0	2.002024e+09	NaN	0.0	96.0	NaN	0.0	NaN	NaN	207.0	NaN
8	14700	NaN	1.06	94451457	887603.0	20.0	NaN	391483.0	NaN	13.0	2020-07-16 12:35:00	891909.0	2.002024e+09	NaN	0.0	96.0	NaN	0.0	NaN	NaN	195.0	NaN
9	17494	NaN	1.41	94849841	887603.0	20.0	NaN	391483.0	NaN	13.0	2020-07-16 11:37:00	891909.0	2.002024e+09	NaN	0.0	96.0	NaN	0.0	NaN	NaN	240.0	NaN

Last rows

	df_index	index_train	length	car_number	destination_esr	adm	danger	gruz	loaded	operation_car	operation_date	operation_st_esr	operation_st_id	operation_train	receiver	rodvag	rod_train	sender	ssp_station_esr	ssp_station_id	tare_weight	weight_brutto
418	4055756	NaN	1.00	52235066	797407.0	20.0	NaN	412196.0	NaN	13.0	2020-07-16 08:46:00	927209.0	2.002025e+09	NaN	5753490.0	60.0	NaN	3144627.0	NaN	NaN	238.0	NaN
419	4067152	NaN	1.06	42162669	700308.0	20.0	NaN	351043.0	NaN	13.0	2020-07-16 14:28:00	980200.0	2.002026e+09	NaN	0.0	40.0	NaN	1126016.0	NaN	NaN	211.0	NaN
420	4083113	NaN	1.06	54448576	700308.0	20.0	NaN	351043.0	NaN	13.0	2020-07-16 14:25:00	980200.0	2.002026e+09	NaN	0.0	40.0	NaN	1126016.0	NaN	NaN	211.0	NaN
421	4097772	NaN	1.00	53415550	797407.0	20.0	NaN	412196.0	NaN	13.0	2020-07-16 06:26:00	927209.0	2.002025e+09	NaN	5753490.0	60.0	NaN	3144627.0	NaN	NaN	233.0	NaN
422	4102574	NaN	1.00	53475653	797407.0	20.0	NaN	412196.0	NaN	13.0	2020-07-16 08:52:00	927209.0	2.002025e+09	NaN	5753490.0	60.0	NaN	3144627.0	NaN	NaN	238.0	NaN
423	4102757	NaN	1.00	53487385	797407.0	20.0	NaN	412196.0	NaN	13.0	2020-07-16 08:32:00	927209.0	2.002025e+09	NaN	5753490.0	60.0	NaN	3144627.0	NaN	NaN	243.0	NaN
424	4110631	NaN	1.00	56876881	797407.0	20.0	NaN	412196.0	NaN	13.0	2020-07-16 08:40:00	927209.0	2.002025e+09	NaN	5753490.0	60.0	NaN	3144627.0	NaN	NaN	225.0	NaN
425	4111004	NaN	1.00	56923824	797407.0	20.0	NaN	412196.0	NaN	13.0	2020-07-16 08:24:00	927209.0	2.002025e+09	NaN	5753490.0	60.0	NaN	3144627.0	NaN	NaN	236.0	NaN
426	4147633	NaN	1.00	62178389	797303.0	20.0	NaN	351306.0	NaN	13.0	2020-07-16 09:02:00	927209.0	2.002025e+09	NaN	5753490.0	60.0	NaN	3144627.0	NaN	NaN	240.0	NaN
427	4163938	NaN	1.00	60644879	797407.0	20.0	NaN	412196.0	NaN	13.0	2020-07-16 06:52:00	927209.0	2.002025e+09	NaN	5753490.0	60.0	NaN	3144627.0	NaN	NaN	237.0	NaN

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows